USE [totem]
GO

/****** Object:  StoredProcedure [dbo].[UDPRequerimiento]    Script Date: 06/29/2012 00:33:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[UDPRequerimiento]
@idRequerimiento int,
@XmlRequerimiento xml

AS

BEGIN

DECLARE @Xml xml = @XmlRequerimiento;

UPDATE REQUERIMIENTO 
SET XMLCONTENIDO = @Xml
WHERE ID_REQUERIMIENTO = @idRequerimiento  
		
END

SET ANSI_NULLS ON



GO

